<div class="page-header">
    <h1>
        Saldo Akun
        <small>
            <i class="icon-double-angle-right"></i>
            Saldo Akun Member
        </small>
    </h1>
</div>

<div class="row">
    <div class="col-xs-11">
        <!-- PAGE CONTENT BEGINS -->
        <form id="frm" class="form-horizontal" role="form" action="" method="post">
            
                <div class="form-group">
                    <label class="col-sm-2 control-label no-padding-right" for="transType"> Nomor Akun </label>
                    <div class="col-sm-9">
                            <input type="text" class="easyui-text" style="width:150px" name="accNum" id="accNum" placeholder="Nomor Akun" value=""></input>
                            <button class="btn btn-info btn-sm" type="button" onclick="cari()">
                                Cari
                            </button>
                    </div>
                </div>
                
        </form>
        <br>



        <table id="grid-table"></table>

        <div id="grid-pager"></div>

        <br>
       <label class="col-sm-2 control-label no-padding"> Total Saldo </label>
        <div class="col-sm">
                <?php echo number_format($this->dataSaldo['saldo']);?>
        </div>
        
        <script type="text/javascript">
                var $path_base = "/";//this will be used in gritter alerts containing images
        </script>

        <!-- PAGE CONTENT ENDS -->
    </div>
</div>


<script>

    
    jQuery(function($) {

            jQuery('#grid-table').jqGrid({
                url:'<?php echo $this->url() ?>/../../jsondata/saldoadmin',
                datatype: "json",
                height: 200,
                colNames:['Nomor Akun','Nama Akun','Bank','No Rekening','Saldo'],
                colModel:[
                    {name:'NoAkun',index:'account_num', width:300},
                    {name:'NamaAkun',index:'account_name', width:300},
                    {name:'Bank',index:'bank_name', width:300},
                    {name:'NoRek',index:'bank_acc_no', width:300},
                    {name:'Saldo',index:'amount', width:300, align:"right", formatter:"number"}
                ],
                rowNum:10,
                rowList:[10,20,30],
                pager: '#grid-pager',
                sortname: 'Tanggal',
                viewrecords: true,
                sortorder: "desc",
                caption:"Saldo Akun Member",
                rownumbers: true,
                loadComplete : function() {
                        var table = this;
                        setTimeout(function(){
                                updateActionIcons(table);
                                updatePagerIcons(table);
                                enableTooltips(table);
                        }, 0);
                },

                autowidth: true
            });

            jQuery('#grid-table').jqGrid('navGrid','#grid-pager',{edit:false,add:false,del:false});


            //navButtons
            jQuery('#grid-table').jqGrid('navGrid','#grid-pager',
                    { 	//navbar options
                            search: true,
                            searchicon : 'ui-icon-search orange',
                            refresh: true,
                            refreshicon : 'ui-icon-refresh green'
                    }
            )




            //unlike navButtons icons, action icons in rows seem to be hard-coded
            //you can change them like this in here if you want
            function updateActionIcons(table) {

                    var replacement =
                    {
                            'ui-icon-search' : 'ui-icon-search orange',
                            'ui-icon-refresh' : 'ui-icon-refresh green'
                    };
                    $(table).find('.ui-pg-div span.ui-icon').each(function(){
                            var icon = $(this);
                            var $class = $.trim(icon.attr('class').replace('ui-icon', ''));
                            if($class in replacement) icon.attr('class', 'ui-icon '+replacement[$class]);
                    })

            }

            //replace icons with FontAwesome icons like above
            function updatePagerIcons(table) {
                    var replacement =
                    {
                            'ui-icon-seek-first' : 'icon-double-angle-left bigger-140',
                            'ui-icon-seek-prev' : 'icon-angle-left bigger-140',
                            'ui-icon-seek-next' : 'icon-angle-right bigger-140',
                            'ui-icon-seek-end' : 'icon-double-angle-right bigger-140'
                    };
                    $('.ui-pg-table:not(.navtable) > tbody > tr > .ui-pg-button > .ui-icon').each(function(){
                            var icon = $(this);
                            var $class = $.trim(icon.attr('class').replace('ui-icon', ''));

                            if($class in replacement) icon.attr('class', 'ui-icon '+replacement[$class]);
                    })
            }

            function enableTooltips(table) {
                    $('.navtable .ui-pg-button').tooltip({container:'body'});
                    $(table).find('.ui-pg-div').tooltip({container:'body'});
            }

            //var selr = jQuery(grid_selector).jqGrid('getGridParam','selrow');

    });

    function downloadExcel(){

        var num = jQuery('#grid-table').jqGrid('getGridParam','records');

        if (num > 0){

            $.ajax({
            type: 'GET',
            dataType: 'text',
            url: '<?php echo $this->url() ?>/../../excel/cetaksn',
            data: {num: num},
            success: function(result){

                        if (result == "TIMEOUT"){
                            location.href = "<?php echo $this->url() ?>/../../admin";
                        }else{
                            location.href = "<?php echo $this->url() ?>/../../excel/"+result;
                        }
                 }
            });

        }else alert('Tidak terdapat SN Baru, silahkan lakukan Generate SN terlebih dahulu.');

    }



    function cari(){

        var accNum = $('#accNum').val();
                

        jQuery("#grid-table").jqGrid('setGridParam',{
            url:"<?php echo $this->url() ?>/../../jsondata/saldoadmin?accNum="+accNum
        }).trigger("reloadGrid");

    }




</script>




